47
How can I prevent grouping by a specified column
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DataColumns.Item['Freight'].AllowGroupBy := EXPIVOTLib.AllowGroupByEnum.exGroupByNone;
end
46
How can I sort alphabetically the columns to be displayed in the context menu/floating panel

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarContextSortAscending) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
	PivotColumnsSortOrder := EXPIVOTLib.PivotColumnsSortOrderEnum.exPivotColumnsAscending;
	PivotColumnsFloatBarVisible := True;
end
45
How can I prevent dropping data to the control
with AxPivot1 do
begin
	AllowDrop := False;
end
44
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exHideFilterPattern) Or Integer(EXPIVOTLib.FilterListEnum.exFilterListDefault);
end
43
How can I prevent showing the Filter For field in the drop down filter window

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exHideFilterPattern) Or Integer(EXPIVOTLib.FilterListEnum.exFilterListDefault);
end
42
How can I display the numeric columns only when selecting a new aggregate, like SUM

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0[bold]';
	PivotColumns := 'sum(5)/12,count(5)/12';
	DataColumns.Item['Freight'].SortType := EXPIVOTLib.SortTypeEnum.SortNumeric;
end
41
How can I add a value column

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
end
40
I would like to always have the subtotals in the same row of the "father row". Could that be done

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0[bold],2';
	PivotColumns := 'sum(5)/12,count(5)/12';
	ShowViewCompact := Integer(EXPIVOTLib.ShowViewCompactEnum.exViewCompactAggregates) Or Integer(EXPIVOTLib.ShowViewCompactEnum.exViewCompact);
	PivotTotals := '/sum,sum(0)';
end
39
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib.ShowBranchRowsEnum.exBranchCompact;
	PivotColumns := 'sum(5)/12[filter=''gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI=''],count(5)/12[filter=''gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZr' + 
	'MJnMoAgI='']';
	ShowViewCompact := Integer(EXPIVOTLib.ShowViewCompactEnum.exViewCompactKeepSettings) Or Integer(EXPIVOTLib.ShowViewCompactEnum.exViewCompact);
end
38
How can I summarize more fields in the same cell

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib.ShowBranchRowsEnum.exBranchCompact;
	PivotColumns := 'sum(5)/12,count(5)/12';
	ShowViewCompact := EXPIVOTLib.ShowViewCompactEnum.exViewCompact;
end
37
How do I programmatically group by rows, in a compact way, no hierarchy lines

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib.ShowBranchRowsEnum.exBranchCompact;
end
36
How do I programmatically group by rows

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0,1,2';
	LinesAtRoot := EXPIVOTLib.LinesAtRootEnum.exLinesAtRoot;
	HasLines := EXPIVOTLib.HierarchyLineEnum.exSolidLine;
end
35
How do I programmatically group by columns

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12;6';
end
34
How can I hide the add new button on the pivot bar

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarHideAddNew) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
end
33
Is it possible to show the data that generated the result, when double clicking the row

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0[italic]';
	PivotColumns := 'count(0)[underline]';
	PivotTotals := 'count[bold,strikeout]';
	ShowDataOnDblClick := True;
	EndUpdate();
end
32
Does your control support subscript or superscript, in HTML captions

with AxPivot1 do
begin
	HeaderHeight := 22;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DataColumns.Item['ShipCountry'].Caption := 'ShipCountry<font ;7><off 6><sha ;;0>subscript';
	DataColumns.Item['ShipRegion'].Caption := 'ShipRegion<font ;7><off -6><sha ;;0>superscript';
	Refresh();
end
31
Is it possible to define a different background color for the pivot bar

with AxPivot1 do
begin
	set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarBackColor,$f0f0f0);
end
30
How can I display an icon/image to Content sub-menu

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	FormatContents.Item['numeric'].Name := '<img>1</img> Numeric';
	PivotRows := '5[content=numeric]';
end
29
How can I change the selection background in the control's context menu

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exSelBackColorFilter,$ff);
end
28
How can I display the column as date in a long format

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatContents.Add('longdate','longdate(date(value))',Nil);
	PivotRows := '9[content=longdate]';
end
27
Is it possible to display the column in upper-case

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatContents.Add('upper','upper(value)',Nil);
	PivotRows := '0[content=upper]';
end
26
How can I programatically bold a column

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0[bold]';
end
25
How can I display the total with a different foreground color

with AxPivot1 do
begin
	FormatAppearances.Add('fore',Nil).ForeColor := $ff;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[fore,bold]';
end
24
How can I display the total with a different background color/ebn 

with AxPivot1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	FormatAppearances.Add('back',Nil).BackColor := $1000000;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end
23
How can I display the total with a solid background color

with AxPivot1 do
begin
	FormatAppearances.Add('back',Nil).BackColor := $f0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end
22
Is it possible to change the "bold" caption in the control's context menu

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatAppearances.Item['bold'].Name := 'Ingrosat';
end
21
Is it possible to show no Exclude field in the filter window

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exShowCheckBox) Or Integer(EXPIVOTLib.FilterListEnum.exSortItemsAsc);
end
20
How can I prevent showing the drop down filter button

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DisplayFilterList := EXPIVOTLib.FilterListEnum.exNoItems;
end
19
How do I get the count of positive values only

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	Aggregates.Add('positive','sum',Nil,Nil).FormatValue := 'value < 0 ? 0 : 1';
	PivotRows := '0';
	PivotColumns := 'positive(5)';
end
18
How do I get the sum for negative values only

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	Aggregates.Add('negative','sum',Nil,Nil).FormatValue := 'value < 0 ? value : 0';
	PivotRows := '0';
	PivotColumns := 'negative(5)';
end
17
My data stores the data as strings, is it possible to load the data using Import method

with AxPivot1 do
begin
	Import('''string 1'';''string 2''#''string 3'';''string 4''','str=`''` eor=''#'' eof='';'' hdr=0');
end
16
Is it possible to load data using different separators

with AxPivot1 do
begin
	Import('item 1;item 2#item 3;item 4','eor=''#'' eof='';'' hdr=0');
end
15
Is it possible to align a column

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with DataColumns.Item[TObject(0)] do
	begin
		Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
		HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
	end;
	Refresh();
end
14
How can I change by code the column/rows background color

with AxPivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatAppearances.Add('aka',Nil).BackColor := $1000000;
	PivotRows := '0[aka]';
	EndUpdate();
end
13
How can I apply by code any appearance to my list

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0[italic]';
	PivotColumns := 'count(0)[underline]';
	PivotTotals := 'count[bold,strikeout]';
	EndUpdate();
end
12
How can I display an icon instead SUM/Total field

with AxPivot1 do
begin
	BeginUpdate();
	Images('gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAVj' + 
	'ILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJI' + 
	'oyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag==' + 
	'');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with Aggregates.Item['sum'] do
	begin
		Name := '<img>1</img> Sum';
		Caption := '<img>1</img>';
	end;
	PivotColumnsFloatBarVisible := True;
	FormatPivotHeader := 'iaggregate ? (caggregate + (iaggregate != 5 ? '' '' : '''') + caption) : caption';
	FormatPivotTotal := 'caggregate';
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
11
How can I change the caption to be displayed when dragging an aggregate function

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotColumnsFloatBarVisible := True;
	FormatPivotHeader := '(iaggregate ? (''<b>'' + upper(caggregate) + ''</b> of '' + caption) : caption)';
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
10
I am using Import method, just wondering if I can rename the columns

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with DataColumns.Item[TObject(0)] do
	begin
		Caption := 'New Caption';
		PivotCaption := 'New Pivot Caption';
	end;
	Refresh();
end
9
Does your control support Fit-To-Page Print and Print Preview

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0,1,2';
	ExpandAll();
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
	begin
		Options := 'FitToPage = On';
		PrintExts := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot);
		Preview();
	end;
end
8
How can I print the control

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0,1,2';
	ExpandAll();
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
	begin
		PrintExts := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot);
		Preview();
	end;
end
7
How can I hide the pivot bar (hide completly)

with AxPivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable);
end
6
How can I hide the pivot bar (auto-hide)

with AxPivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoHide) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
end
5
How can I count and get the total of a specified column

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotColumnsFloatBarVisible := True;
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
4
How can I add show the columns once I grouped a column

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumnsFloatBarVisible := True;
end
3
How can I programatically group the columns

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0:D';
end
2
Is it possible to load data from a data source

with AxPivot1 do
begin
	rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Nil);
	end;
	DataSource := (rs as ADODB.Recordset);
end
1
How can I load data

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
end